Adventures in Excel - the Simple but Powerful Functions you need

What you'll learn

• Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT

• Useful date functions including TODAY, EOMONTH, EDATE, and DAYS

• Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table

• The new RANDARRAY function in Office365

• The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS

• Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE

• Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR

• How to create a drop-down list

• The new SORT and FILTER functions in Office365

• VLOOKUP and the new XLOOKUP function

• How to create a Pivot table and analyse data with one

• Introduction 1:31:46

  • 1: Adventures in Excel Introduction Preview 03:01
  • 2: L1 Basic Functions Preview 11:58
  • 3: L2 Date Functions 08:46
  • 4: L3 Random Numbers 08:36
  • 5: L4 IFS so many IFS 10:31
  • 6: L5 Text Functions 13:14
  • 7: L6 Logical Functions 09:24
  • 8: L7 Creating a Drop Down List 05:13
  • 9: L8 VLOOKUP and XLOOKUP 09:09
  • 10: L9 Pivot Tables 07:54
  • 11: Test Questions 04:00

Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often:

· Basic features including SUM, AVERAGE, MAX, MIN, PRODUCT, SQRT and POWER

· Key date functions including the calculation of due dates and days past due using EOMONTH, EDATE and DAYS

· Generating random numbers and random dates with RAND and RANDBETWEEN, and introducing the new RANDARRAY function

· The new IFS functions (new to Office365) - AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS and SUMIFS

· Text functions including TRIM, UPPER, LOWER, PROPER, LEFT, RIGHT, MID, FIND, and TEXTJOIN

· The most useful logical functions and IS functions - AND, OR, NOT, ISBLANK, ISTEXT, ISNUMBER and ISERROR

· How to create a drop-down list

· The new XLOOKUP function and how it compares with the popular VLOOKUP function

· Pivot tables - how to create one and how to use one to analyse data

There is so much in Microsoft Excel that I can’t cover it all in one course – that might need 100 courses. Instead, in this course – Adventures in Excel - I start with some simple calculations and move onto some of the features and functions that I use most often. There’s no visual basic or macros in here just powerful but simple to use functions. These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time.

I hope you find the course helpful.

• Students of business
• Anyone wanting to develop their Microsoft Excel skills

• There are no pre-course requirements

Currently there are no Q&As for this course. Be the first to ask a question.

Reed courses certificate of completion

Digital certificate - Included